GRC-102FT: Conquering DAX 2019 [Fastrack]

DAX isn’t just a formula language—it’s the key to unlocking deep, meaningful analytics in Power BI, Power Pivot, and SSAS Tabular models. This 3-day intensive Conquering DAX 2019 [Fastrack] course is designed to help you truly understand and master DAX from the ground up.

Participants will dive into foundational concepts such as calculated columns, measures, and common aggregation functions. From there, the course progresses into advanced areas including filter and row contexts, table functions, CALCULATE logic, iterators, and relationship management.

One of the course’s core strengths is its focus on practicality. With 10 hands-on labs covering over 40 real-world scenarios, you'll apply DAX in business contexts like customer ranking, YOY comparisons, sales segmentation, time intelligence, and handling many-to-many relationships.

Key highlights include:

• Deep exploration of DAX’s evaluation context, shadow filters, and variables.

• How to write readable and efficient DAX using functions like CALCULATE, FILTER, RANKX, and ALLSELECTED.

• The use of segmentation, parent-child hierarchies, and bi-directional filtering techniques.

• Business cases that challenge your thinking, such as computing percentages, analyzing delivery times, and segmenting product performance.

This course is ideal for Power BI users, Excel pros, or SSAS developers ready to take their skills to the next level. Basic data modeling knowledge is recommended before enrolling.

By the end of this training, you’ll not only write better DAX—you’ll think in DAX, and build models that solve real business problems with accuracy and elegance.